UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiLp2NkqznCokm4Z9lok6P9Rbt4g2Gz9ajtbAEH0IUk='
WHERE
key_id = '6bcb628962d71666a1e84ea48141764cfa186a4bd928b6e784ee3cd51e5e5ec7'
AND (
token = 'ZiLp2NkqznCokm4Z9lok6P9Rbt4g2Gz9ajtbAEH0IUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)