UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mf3ryZILKYlgDI/y+L73eV3wF29u0NiuyuHErf0mlVA='
WHERE
key_id = 'd7720ba7ed8dd9853fc46a890ec7c2f515a2277b9a19995710076ff242c8d7ac'
AND (
token = 'mf3ryZILKYlgDI/y+L73eV3wF29u0NiuyuHErf0mlVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)