UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zegVBMDHA+Dc1qeEdbGIgcBy3yuvARLLTumCNfrmn+w='
WHERE
key_id = '8ca2886ce60cc36fb14142a418ecf7ff1944f94d5fb1f0812a0c6ee98ae1cfee'
AND (
token = 'zegVBMDHA+Dc1qeEdbGIgcBy3yuvARLLTumCNfrmn+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)