UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBQiLWlVj44Sf+NN18x0oPBILMDf1gn9PfmfCC8pTXI='
WHERE
key_id = '20c6f06577155d9d157da9f9ffd06aa776bfa28191cf0f9cd19f8ff82f13d994'
AND (
token = 'vBQiLWlVj44Sf+NN18x0oPBILMDf1gn9PfmfCC8pTXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)