UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'doWtE/8qcW5qCh0+2Wa+hA8oMVJK6jJInFQmKKb7iiQ='
WHERE
key_id = 'f132ae86c949822d8ec37235e3e17a02d5099097da60a8aba23146f9f4817d14'
AND (
token = 'doWtE/8qcW5qCh0+2Wa+hA8oMVJK6jJInFQmKKb7iiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)