UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMW4g4rCHdiPAUdMRwrms7JaHZD1/5YexQ04cFpeqdM='
WHERE
key_id = '0ebe07d3653586012495ccae4313ec3fd607503b92c2765a183018e888016e79'
AND (
token = 'ZMW4g4rCHdiPAUdMRwrms7JaHZD1/5YexQ04cFpeqdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)