UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qUuVAc4fjcp8Qn5oQGNn/prJUph7pC5we5QWLi+2qrw='
WHERE
key_id = '2eac88a367c52051d3dcaff86c80a2b9cafcd8bb7ad2b36d22b58dc495d7cc8a'
AND (
token = 'qUuVAc4fjcp8Qn5oQGNn/prJUph7pC5we5QWLi+2qrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)