UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8VdPO6T/AFfkqVTrHA2mKAgDfng/aBPWwoRgs1Sbws='
WHERE
key_id = '80359243078f2f61e9ba23b4d55710c39b869c99af2dc65e27dd87547d7d2462'
AND (
token = 'i8VdPO6T/AFfkqVTrHA2mKAgDfng/aBPWwoRgs1Sbws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)