UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCQ68Uzoe25BivmdWwy0172cp5FAaY0CcIoHGQ/LRdQ='
WHERE
key_id = 'c20fb6330e4591406707a86e07a849363e901d9ea5b7a649a254b8ebfe870bb0'
AND (
token = 'zCQ68Uzoe25BivmdWwy0172cp5FAaY0CcIoHGQ/LRdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)