UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQgzKC9R9f2qgaqpnMV0AVWdSimoxwVAItNRiCTkNMo='
WHERE
key_id = 'f2fecfa8d45073e112c0d579c3f9546f0ed81a748aaa06094ccd40a2b4364036'
AND (
token = 'HQgzKC9R9f2qgaqpnMV0AVWdSimoxwVAItNRiCTkNMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)