UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnY/cT07sw/ACAg0dfTVLh3X24vaL0JcHiA//NAzpak='
WHERE
key_id = 'c1f0850359dc1616caf75ca351e0c4b66cffaecb55ecc4d05a514fd78c50265f'
AND (
token = 'QnY/cT07sw/ACAg0dfTVLh3X24vaL0JcHiA//NAzpak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)