UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h2KbinR9s9X3foo/ELcSKALxG/QdfQGne547OpZdoVM='
WHERE
key_id = 'c93e64ad018d380c196fcd560cc17e95f865ed14ffb082a14bc404664b4cf350'
AND (
token = 'h2KbinR9s9X3foo/ELcSKALxG/QdfQGne547OpZdoVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)