UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1aEYFCPUZh7HoRDwaIzxMQ699KMRjyTnCZrwj8XdPxU='
WHERE
key_id = 'fbc0c60291b9cc06ad87b0475b04e7b7a954eb3501df3c61b0a6fb6b3c638a13'
AND (
token = '1aEYFCPUZh7HoRDwaIzxMQ699KMRjyTnCZrwj8XdPxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)