UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzYDLhxBuWbFO3ijg9qfNhAMPh+liVjr+eo4Avs3yG8='
WHERE
key_id = 'd7345007f79e98eece69d73ac3cef2090db7598e1877b6b3eeba76bed180c63a'
AND (
token = 'zzYDLhxBuWbFO3ijg9qfNhAMPh+liVjr+eo4Avs3yG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)