UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yzy4X3HzjAJTSygH0LW1vIxB+ff5AftHbmHbs9qzSjU='
WHERE
key_id = 'a18431804609049079c07c95ab7f58b6b5e37e12890db99918071ef783d8ef46'
AND (
token = 'yzy4X3HzjAJTSygH0LW1vIxB+ff5AftHbmHbs9qzSjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)