UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/4AmICiz5rgzdEFY8DZCUze2phbBoOdRIneYMZLFr0='
WHERE
key_id = '580563dc4ee367ffb72812b0d6e9e44adfb49b6274a80e2a9a9c9e10984f2930'
AND (
token = 'z/4AmICiz5rgzdEFY8DZCUze2phbBoOdRIneYMZLFr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)