UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XkTavlfEn/CLIrnbrlxdlQpwKiDrYrINRKcS3O+IjLY='
WHERE
key_id = '78a38929041b2c65f4eb42cb27ee0f2d8cac68a8323fae44fde44e2dfdc3f564'
AND (
token = 'XkTavlfEn/CLIrnbrlxdlQpwKiDrYrINRKcS3O+IjLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)