UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B+ILz1cE0969LUiAn0BJjsykU1kCj4dJqTKUlML3BsE='
WHERE
key_id = 'b998f49249f2d2fcd4e084fe96ce4866ff9ba96ce60ede185c597b8e186bb328'
AND (
token = 'B+ILz1cE0969LUiAn0BJjsykU1kCj4dJqTKUlML3BsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)