UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z/wy5n9DT1/wyrSoVP7RBpXlAYh4cnKnT6hconqADt0='
WHERE
key_id = '47715fdffc08544f943c192c115799db54a741bb19453c732cd60768e6d6abf5'
AND (
token = 'Z/wy5n9DT1/wyrSoVP7RBpXlAYh4cnKnT6hconqADt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)