UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25g6bj8ZAUjMEYMMIxMkHLpx5SiDRf50xNz67P7mFEo='
WHERE
key_id = '06fbd9faeb7a33dc562d2ddc2eb874ddb13182f9e9f87dd156de410aff949bfb'
AND (
token = '25g6bj8ZAUjMEYMMIxMkHLpx5SiDRf50xNz67P7mFEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)