UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EUSG3mjJ7ASrvbvR0x8rdvwNJrX4WgpzG7V3zaBr60='
WHERE
key_id = 'a78ca18fb6062d026ef1ffc8573b526dd5b31ad635ce633072c8e1a9e9fac94d'
AND (
token = '4EUSG3mjJ7ASrvbvR0x8rdvwNJrX4WgpzG7V3zaBr60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)