UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iz51bFkpYEGk4GT/Ornz5/Hfjuy29HCa2tkjceAM/vw='
WHERE
key_id = 'b8ea7e029b2b9464e0cdf5b952cf7275beda5ddf7c8735bbd2799446d642562a'
AND (
token = 'iz51bFkpYEGk4GT/Ornz5/Hfjuy29HCa2tkjceAM/vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)