UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7UdvCShmjpKXbw15sgRoutEituvR6uXHqrQkHx5tjo='
WHERE
key_id = '9abaf482d3e65a974c306958e82385ff4d50c0d6a5aa6fddfc137de9c98755d0'
AND (
token = 'W7UdvCShmjpKXbw15sgRoutEituvR6uXHqrQkHx5tjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)