UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgop9AUNY+iu64QZyYKAb7uqRT+52todhszOYoMmES8='
WHERE
key_id = '30f62d101919a3d1dde9aa5cb0a1761cfbeec7c661aa188c6f7d064dfbd97587'
AND (
token = 'lgop9AUNY+iu64QZyYKAb7uqRT+52todhszOYoMmES8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)