UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7nYJ7+AIN0Zdmee6/dDaudxCfUyD3+zGT16QcrT1WrI='
WHERE
key_id = 'ba28cb0629c0f3d87f1d2b03841c4e296d760fd240195fba8a3c0ff42b4cb36a'
AND (
token = '7nYJ7+AIN0Zdmee6/dDaudxCfUyD3+zGT16QcrT1WrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)