UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZVVC8Pycl2a7UmRrbxQkKZhhQNGzGxd2LImOxGCsAE='
WHERE
key_id = 'd88f1e8b6b0c0956ca5a67646a13f1b93c767e79f259a253b52505257f1e26c9'
AND (
token = '0ZVVC8Pycl2a7UmRrbxQkKZhhQNGzGxd2LImOxGCsAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)