UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hfg3aQLTGpplOgKuI1P766LaNHFjKi6zLXv9wZ4nLB4='
WHERE
key_id = '8097e4485ba9400a163836b4343e728c58e8983a997a3ed4290fbd3d090b27ba'
AND (
token = 'Hfg3aQLTGpplOgKuI1P766LaNHFjKi6zLXv9wZ4nLB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)