UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQZOdLpLeUGL2ifCVbjdiEFiEe6sKiE51WjivKJLHWY='
WHERE
key_id = '1a78d5b94d97f4d68dc2bfbe12244b4f2d7f715cd55db678bb191329150e4244'
AND (
token = 'XQZOdLpLeUGL2ifCVbjdiEFiEe6sKiE51WjivKJLHWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)