UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TrSQc0/PCLNbzyApguoCwLJbLvTCahz6HC1/hlMmHHM='
WHERE
key_id = 'f3effa808fffcb9bce60f8dd14362403d7c22edcc7353dba2b657905b0ce2602'
AND (
token = 'TrSQc0/PCLNbzyApguoCwLJbLvTCahz6HC1/hlMmHHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)