UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fSwoaJfGiqZNJm1xOlFoUYECSVigPA5dVqk6PTzhauU='
WHERE
key_id = 'd2f1b09487e961ffebb1e5c425570d6262956003c7fdf631d73e07eca3dc0b2b'
AND (
token = 'fSwoaJfGiqZNJm1xOlFoUYECSVigPA5dVqk6PTzhauU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)