UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Z+v8BBmZNCZzLse7SRhFTPzZ907Y8AWZcQtUKUnxfI='
WHERE
key_id = '3e9192d1791b0c9182828c9383e6c70f8be3120798ed8f6df83726e491686181'
AND (
token = '4Z+v8BBmZNCZzLse7SRhFTPzZ907Y8AWZcQtUKUnxfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)