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