UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ki9hEMlyCfQYNH6OjKYB7OczIP6gmAg9rMNMZupts90='
WHERE
key_id = '24eb0ed95a0e48ffb9339637b8baf2b8d10052339ea310fc16f12ec567ab4d9e'
AND (
token = 'Ki9hEMlyCfQYNH6OjKYB7OczIP6gmAg9rMNMZupts90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)