UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pr0qdtaqXT+neBOXZto/issKkEvwgtKD5bF/jUXwow='
WHERE
key_id = '8bbfa726ecef00d90d29f35589a2cd37b0cf5d1c414179a77aae2a75eb4ec907'
AND (
token = '6pr0qdtaqXT+neBOXZto/issKkEvwgtKD5bF/jUXwow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)