UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AAffwlOeyUnjBuFc+R4hVa3+rSRNF2y8aIhK/t/GOYg='
WHERE
key_id = 'c00ed2d2b8119960279e922d660a8071a7b634ee7f171c2180b29fe1ba16e13f'
AND (
token = 'AAffwlOeyUnjBuFc+R4hVa3+rSRNF2y8aIhK/t/GOYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)