UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qCACyE3hBP3RfF3v70Csm39ED5v2pf1Xrff2pgoU70g='
WHERE
key_id = 'a5aaad47e0180c48f4e13d5352be0edacc8c5d680c464868da13d32f48db4f26'
AND (
token = 'qCACyE3hBP3RfF3v70Csm39ED5v2pf1Xrff2pgoU70g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)