UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tDav4RiJJWpxSy8oOU1dbs4Xz1TMAmJsGJjtngCgxC8='
WHERE
key_id = '97364569677f475de72133424ed46fb6c9cb4ed0e60eca1bc0ed68fb5e45eb6a'
AND (
token = 'tDav4RiJJWpxSy8oOU1dbs4Xz1TMAmJsGJjtngCgxC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)