UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiVJE74wiytcTzY3ofZyKiZFlHn8sy95PaKCXZPqfbE='
WHERE
key_id = '8eb5038d9f0d282823d1ff410078b0313a3c33892232422a31dfd4ebc2d3c8b6'
AND (
token = 'ZiVJE74wiytcTzY3ofZyKiZFlHn8sy95PaKCXZPqfbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)