UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3D4wCg1v2kJMY/Z8DLlrYDqUhBaprHP8EccxpjHoqk8='
WHERE
key_id = '04580907c14a574f7e81817442289045cdae9b395ddc2c8425f7e050eed99836'
AND (
token = '3D4wCg1v2kJMY/Z8DLlrYDqUhBaprHP8EccxpjHoqk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)