UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w/5aYYw+38qV9qmu4mDghNo/xHILUvb8MA9AcYy3Beo='
WHERE
key_id = '1b563ffc4580cd8463772880d5bda4fb03e0d2d3c1997696ab245d116dfc2110'
AND (
token = 'w/5aYYw+38qV9qmu4mDghNo/xHILUvb8MA9AcYy3Beo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)